PROMPT *-*-*-*-*-*- rep_gen_dtl_tb table creation STARTS...   *-*-*-*-*-*-*

DROP TABLE rep_gen_dtl_tb;

CREATE TABLE rep_gen_dtl_tb
(
  rep_id      NUMBER
, ctry_cd     VARCHAR2(10)
, dir_nm      VARCHAR2(10)
, filename    VARCHAR2(40)
, file_dtfmt  VARCHAR2(10)
, ext         VARCHAR2(10)
, f_mode      VARCHAR2(2)
, dlimit      VARCHAR2(1)
, hdr_txt     VARCHAR2(50)
, hdr_dtfmt   VARCHAR2(15)
, ftr_txt     VARCHAR2(50)
, ftr_dtfmt   VARCHAR2(15)
, ftr_size    NUMBER
, ftr_fill    NUMBER
, hf_cnt_req  VARCHAR2(3)
);

PROMPT *-*-*-*-*-*- rep_gen_dtl_tb table creation ENDS...   *-*-*-*-*-*-*

PROMPT *-*-*-*-*-*- Inserting into rep_gen_dtl_tb table STARTS...   *-*-*-*-*-*-*


INSERT INTO rep_gen_dtl_tb
    (rep_id,
     ctry_cd,
     dir_nm,
     filename,
     file_dtfmt,
     ext,
     f_mode,
     dlimit,
     hdr_txt,
     hdr_dtfmt,
     ftr_txt,
     ftr_dtfmt,
     ftr_size,
     ftr_fill,
     hf_cnt_req)
VALUES
    ('1000',
     'IND',
     'DIR_1',
     'IND_REPORT_<date>',
     'DDMMYY',
     '.txt',
     'W',
     '~',
     'HDR_<date>',
     'DDMMYY',
     'FTR_<date>',
     'DDMMYY',
     5,
     0,
     'Y');


INSERT INTO rep_gen_dtl_tb
    (rep_id,
     ctry_cd,
     dir_nm,
     filename,
     file_dtfmt,
     ext,
     f_mode,
     dlimit,
     hdr_txt,
     hdr_dtfmt,
     ftr_txt,
     ftr_dtfmt,
     ftr_size,
     ftr_fill,
     hf_cnt_req)
VALUES
    ('1000',
     'SIN',
     'DIR_1',
     'SIN_REPORT_<date>',
     'DDMMYYYY',
     '.txt',
     'W',
      NULL,
     'HD_<date>',
     'DDMMYYYY',
     'FT_<date>',
     'DDMMYYYY',
     5,
     0,
     'N');

INSERT INTO rep_gen_dtl_tb
    (rep_id,
     ctry_cd,
     dir_nm,
     filename,
     file_dtfmt,
     ext,
     f_mode,
     dlimit,
     hdr_txt,
     hdr_dtfmt,
     ftr_txt,
     ftr_dtfmt,
     ftr_size,
     ftr_fill,
     hf_cnt_req)
VALUES
    ('1000',
     'US',
     'DIR_1',
     'US_REPORT_<date>',
     'DDMMYYHHMI',
     '.txt',
     'W',
     ',',
     'H_<date>',
     'DDMMYY',
     'F_<date>',
     'DDMMYY',
     5,
     0,
     'Y');


COMMIT;

PROMPT *-*-*-*-*-*- Inserting into rep_gen_dtl_tb table STARTS...   *-*-*-*-*-*-*